
	<?php
	function C9()
	{
	$Servidor = "localhost";
	$Conn = null;
	$Usuario = "root";
	$Contrasena = "favirguezc";
	$Conn=mysql_connect($Servidor,$Usuario,$Contrasena);
	echo '
		<table border = "1">
			<tr>
				<th>Curso</th>
			</tr>';
	    $SQL = 'SELECT CURSO.CUR_Nombre AS curso 
		FROM CURSO,GRUPO,HORARIO
		WHERE CURSO.CUR_Id = GRUPO.CUR_Id AND GRUPO.Hor_Id = HORARIO.Hor_Id AND YEAR(HORARIO.Hor_Dia1) = YEAR(CURRENT_DATE());';
		mysql_select_db("ieee",$Conn);
		$RS = mysql_query($SQL,$Conn);
		while($fila=mysql_fetch_array($RS,MYSQL_ASSOC))
		{
			echo "<tr><td>".$fila["curso"]."</td></tr>";
		} 
		mysql_free_result($RS);
		mysql_close($Conn);
		echo'</table>'.
		'<a href = "Bases.php"> Regresar a Consultas</a>';
	}
	?>
	
